<%-- 
    Document   : user_home.jsp
    Created on : Jan 24, 2013, 1:58:23 AM
    Author     : ritu
--%>
<%
    response.setHeader("Cache-Control", "no-cache");
    if(session.getAttribute("sr")==null)
        response.sendRedirect("index.jsp?msg=Please,Login First");
    %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@include file="connection.jsp" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Cache-Control" content="no-cache"/>
<meta http-equiv="Pragma" content="no-cache"/>
<meta http-equiv="Expires" content="0"/>
<title>Dashboard - Admin Template</title>
<link rel="stylesheet" type="text/css" href="css/theme.css" />
<link rel="stylesheet" type="text/css" href="css/style.css" />
<script>
   var StyleFile = "theme" + document.cookie.charAt(6) + ".css";
   document.writeln('<link rel="stylesheet" type="text/css" href="css/' + StyleFile + '">');
</script>
<link rel="stylesheet" href="js/jquery-ui-1.8.23.custom/development-bundle/themes/base/jquery.ui.all.css">
        <script src="js/jquery-ui-1.8.23.custom/js/jquery-1.7.2.min.js" type="text/javascript"></script> 
        <script src="js/jquery-ui-1.8.23.custom/development-bundle/ui/jquery.ui.core.js"></script>
	<script src="js/jquery-ui-1.8.23.custom/development-bundle/ui/jquery.ui.widget.js"></script>
	<script src="js/jquery-ui-1.8.23.custom/development-bundle/ui/jquery.ui.accordion.js"></script>
        
         
        <script>
    $(function() {
		$( "#sidebar" ).accordion({
			autoHeight:false,
                        event: "mouseover"
		});
	});
    
</script>
<!--[if IE]>
<link rel="stylesheet" type="text/css" href="css/ie-sucks.css" />
<![endif]-->
</head>

<body>
	<div id="container">
    	<div id="header">
        	<h2>Stock Market Website</h2>
    <div id="topmenu">
            	<ul>
                    <li class="current"><a href="user_home.jsp">Dashboard</a></li>
                    <li><a href="portfolio.jsp">Portfolio</a></li>
                    <li><a href="charts.jsp">Charts</a></li>
                    <!--<li><a href="chatgroup.jsp">Chat Group</a></li>-->
                    <li><a href="experts_user.jsp">Experts</a></li>
                    <!--                    <li><a href="emails.jsp">Emails</a></li>-->
              </ul>
          </div>
      </div>
        <%
            String sr=session.getAttribute("sr").toString();
            //String uid=(String)request.getParameter("uid");
            String s="select f_name,l_name,e_mail,mo_no,package.pac_name from user,package where user.pac_id=package.pac_id and sr_no="+sr+" ";
            st=con.createStatement();
            rs=st.executeQuery(s);
        %>               
        <div id="wrapper">
            <div id="content">
                <div id="box">
                    <h3 class="reallynow">Renew Package</h3>
                    <form method="GET" action="renew.jsp">
                        <table border='1'>
                        <%    
                            while(rs.next())
                        {
                            out.print("<tr>");
                                                                           
                            out.print("<td>Name:");
                            out.print("</td>");
                            out.print("<td>");
                            out.print(rs.getString(1)+" "+rs.getString(2));
                            out.print("</td>");
                            out.print("</tr>");
                            
                            out.print("<tr>");
                            out.print("<td>Email:");
                            out.print("</td>");
                            out.print("<td>");
                            out.print(rs.getString(3));
                            out.print("</td>");
                            out.print("</tr>");
                            
                            out.print("<tr>");
                            out.print("<td>Mobile number:");
                            out.print("</td>");
                            out.print("<td>");
                            out.print(rs.getString(4));
                            out.print("</td>");
                            out.print("</tr>");
                            
                            out.print("<tr>");
                            out.print("<td>Current Package:");
                            out.print("</td>");
                            out.print("<td>");
                            out.print(rs.getString(5));
                            out.print("</td>");
                            out.print("</tr>");
                            
                            out.print("<tr>");
                            out.print("<td>Choose Package");
                            out.print("</td>");
                            out.print("<td>");
                        %>
                       <select name="newpack">
                        <option value="">--Choose Package--</option>
                        <option value="micro">MICRO</option>
                        <option value="mini">MINI</option>
                        <option value="kilo">KILO</option>
                        <option value="mega">MEGA</option>
                        <option value="giga">GIGA</option>
                       </select>
                       <%
                            out.print("</td>");
                            out.print("</tr>");
                            out.print("<input type='hidden' name='uid' value='"+sr+"'");
                        }
                        rs.close();
                        %>
                        <tr>
                            <td><input type="submit" value="Submit" /></td>
                            <td><input type="reset" value="Reset" /></td>
                        </tr>
                        </table>
                    </form>
                </div>
            </div>
        </div>
        <div id="sidebar">
  				
                                    <li><h3>
                                    <%
                                        if(session.getAttribute("sr").equals(null)){
                                            response.sendRedirect("index.jsp?msg='Please,Login first'");
                                        }
                                        String id=session.getAttribute("sr").toString();
                                        String name=session.getAttribute("name").toString();
                                        out.print("Welcome "+name);
                                    %></h3><ul></ul></li>         
                	<li><h3><a href="#" class="house">Dashboard</a></h3>
                        <ul>
                        	<li><a href="logout.jsp" class="report">Logout</a></li>
                        </ul>
                    </li>
                    <li><h3><a href="#" class="manage">Manage</a></h3>
          				<ul>
                            <li><a href="user_update.jsp" class="manage_page">Profile</a></li>
                           
                            <li><a href="#" class="promotions">Renew Package</a></li>
                        </ul>
                    </li>
                   <!-- <li><h3><a href="#" class="folder_table">Orders</a></h3>
          				<ul>
                        	<li><a href="#" class="addorder">Emails</a></li>
                          <li><a href="#" class="shipping">Experts</a></li>
                            <li><a href="#" class="invoices">Invoices</a></li>
                        </ul>
                    </li>-->
                    
                 <!-- <li><h3><a href="#" class="user">Portfolios</a></h3>
          				<ul>
                                            
                                            
                            <li><a href="#" class="useradd">Add/Delete user</a></li>
                            <li><a href="#" class="group">Chat groups</a></li>
            				<li><a href="find_user.jsp" class="search">Find user</a></li>
                            <li><a href="#" class="online">Users online</a></li>
                        </ul>
                    </li>-->
				
          </div>
      </div>
        <div id="footer">
        <div id="styleswitcher">
            <ul>
                <li><a href="javascript: document.cookie='theme='; window.location.reload();" title="Default" id="defswitch">d</a></li>
                <li><a href="javascript: document.cookie='theme=1'; window.location.reload();" title="Blue" id="blueswitch">b</a></li>
                <li><a href="javascript: document.cookie='theme=2'; window.location.reload();" title="Green" id="greenswitch">g</a></li>
                <li><a href="javascript: document.cookie='theme=3'; window.location.reload();" title="Brown" id="brownswitch">b</a></li>
                <li><a href="javascript: document.cookie='theme=4'; window.location.reload();" title="Mix" id="mixswitch">m</a></li>
                <li><a href="javascript: document.cookie='theme=5'; window.location.reload();" title="Mix" id="defswitch">m</a></li>
            </ul>
        </div><br />

        </div>
</div>
</body>
</html>
            